home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
trips.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
27 lines
/* RCSVER $Id: trips.sql,v 1.5 2000-01-25 16:34:19-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: trips.sql
* Date: 02/16/1999
* memo: Randy Wood
* Description: Create the trips table. This table contains all valid
* trips for each route.
* Changes:
************************************************************************* */
CREATE TABLE trips
(
routeid NUMBER(38), /* Route id */
runid NUMBER(38), /* Run id */
id NUMBER(38), /* ID of this trip */
descr VARCHAR2(30), /* Description of trip */
dep_time VARCHAR2(5), /* Departure time (scheduled) */
direction1 VARCHAR2(20), /* East/West/etc. */
direction2 VARCHAR2(20), /* Inbound/Outbound etc. */
mileage NUMBER(36,2), /* Mileage for this trip */
waydir NUMBER(38), /* Wayfarer direction */
route_desc VARCHAR2(20), /* Description of route, if needed */
config_num NUMBER(38),
CONSTRAINT pk_trips PRIMARY KEY (routeid, runid, id, config_num)
);